import sqlalchemy
import pandas as pd
from sqlalchemy import create_engine
import pymysql
print(sqlalchemy.__version__)
print(pymysql.__version__)
pymysql.install_as_MySQLdb()
from sqlalchemy.types import *
from pandas.io import sql

df=pd.DataFrame({"班级":["一年级","二年级","三年级","四年级"],
                 "男生人数":[25,23,27,30],
                 "女生人数":[19,17,20,20]})
print(df)
print('\n')

engine =create_engine ('mysql+pymysql://root:123456@127.0.0.1:3306/teaching?charset=utf8')
df.to_sql('students',con=engine,if_exists='replace',index=False)
print(pd.read_sql('students', engine))
print('\n')

import numpy as np
import pandas as pd
data = np.arange(12).reshape((3,4))
df3 = pd.DataFrame(data,index=['d','b','c'],columns=['dd','aa','cc','bb'])
print(df3)
print('\n')

print(df3.sort_index(axis=0))
print('\n')

print(df3.sort_index(axis=1))
print('\n')

print(df3.sort_index(axis=1))
print('\n')

print(df3.sort_values(by='cc'))
print('\n')

df=pd.read_csv(filepath_or_buffer=r'D:\WXWork\python\data.csv')
print(df)
print('\n')

